﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="PointsTimeUp.ascx.cs" Inherits="webUserControl_PointsTimeUp" %>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:LinFen %>" 
    
    
    
    SelectCommand="SELECT NumFemale, NumHongGan, NumBaoJian, NumQiTa, NumMale, endTime, SupplierName, SupplierName2, ID, CustomerName,CustomerID,YeWu FROM vw_OrderDetail WHERE (SupplierID = @SupplierID) AND (Status = 0) ORDER BY endTime DESC">
    <SelectParameters>
        <asp:QueryStringParameter Name="SupplierID" QueryStringField="sID" 
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" 
    AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" 
    DataKeyNames="ID" DataSourceID="SqlDataSource1" Font-Size="12px" 
    ForeColor="#333333" GridLines="None" HorizontalAlign="Center" Width="100%" 
    onrowcommand="GridView2_RowCommand">
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Center" />
    <Columns>
        <asp:BoundField DataField="ID" ReadOnly="True" SortExpression="ID" />
        <asp:BoundField DataField="SupplierName" HeaderText="点位名称" 
            SortExpression="SupplierName" />
        <asp:BoundField DataField="SupplierName2" HeaderText="楼层" 
            SortExpression="SupplierName2" />
        <asp:BoundField DataField="NumMale" HeaderText="男点位" SortExpression="NumMale" />
        <asp:BoundField DataField="NumFemale" HeaderText="女点位" 
            SortExpression="NumFemale" />
        <asp:BoundField DataField="NumHongGan" HeaderText="烘干点位" 
            SortExpression="NumHongGan" />
        <asp:BoundField DataField="NumBaoJian" HeaderText="包间点位" 
            SortExpression="NumBaoJian" />
        <asp:BoundField DataField="NumQiTa" HeaderText="其他点位" 
            SortExpression="NumQiTa" />
        <asp:BoundField DataField="CustomerID" HeaderText="客户编号" 
            SortExpression="CustomerID" />
        <asp:BoundField DataField="CustomerName" HeaderText="客户名称" 
            SortExpression="CustomerName" />
        <asp:BoundField DataField="endTime" HeaderText="合同到期时间" 
            SortExpression="endTime" DataFormatString="{0:d}" />
        <asp:BoundField DataField="YeWu" HeaderText="客户备注" SortExpression="YeWu" />
        <asp:TemplateField ShowHeader="False">
            <ItemTemplate>
                <asp:Button ID="Button1" runat="server" CausesValidation="False" 
                    CommandArgument='<%# Eval("ID") %>' CommandName="shifang" Text="释放" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <EditRowStyle BackColor="#999999" />
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
